package com.bj58.ecdata.calc.dbservice.dao;

import org.springframework.stereotype.Component;

import com.bj58.ecdata.calc.dbservice.dao.model.TrackModel;

/**
 * @author lichao
 *
 */
@Component
public class TrackDao extends BaseDao<TrackModel> {
	
	@Override
	protected String getCreateSQL() {
		  return "CREATE TABLE %s ("
			  +"`time` bigint(20) NOT NULL,"
			  +"`platform` int(4) NOT NULL,"
			  +"`bussline` varchar(20) NOT NULL DEFAULT '',"
			  +"`pv` bigint(11) NOT NULL,"
			  +"`listpv` bigint(11) NOT NULL,"
			  +"`vppv` bigint(11) NOT NULL,"
			  +"`uv` int(11) NOT NULL,"
			  +"KEY `time` (`time`)"
			  +") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
	}
}
